package ConexionBD;

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */


import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import java.sql.*;
/**
 *
 * @author unknow
 */
public class Conexion extends HttpServlet {
        String Base= "db_analisis";
        String Usuario= "root";
        String Contraseña= "12345";
        String Url= "jdbc:mysql://localhost:3307/" + Base;

        Connection MiConexion = null;


public void Estado() throws SQLException{
if(MiConexion.isClosed()){
    javax.swing.JOptionPane.showMessageDialog(null,"Cerrada");
}else {
        javax.swing.JOptionPane.showMessageDialog(null,"Abierta");
}


}




    public void Conectar(){
    
    try{
        Class.forName("com.mysql.jdbc.Driver").newInstance();
        MiConexion = DriverManager.getConnection(Url,Usuario,Contraseña);

        if (MiConexion != null) {
javax.swing.JOptionPane.showMessageDialog(null,"Conectado");

            } else {
javax.swing.JOptionPane.showMessageDialog(null,"NOOOOO Conectado");
            }

}catch(Exception Ex ){

}



    }
    
    public String  get_tipos_usuarios() throws SQLException{
      String res="";
        String sql = "select * from Tipos_Users";
       Statement s = MiConexion.createStatement(); 
       ResultSet rs = s.executeQuery (sql);
      res="<select>";
     while(rs.next()){
         res=res+"<option value="+rs.getInt(1)+">"+rs.getString(2)+"</option>";
     }
     res=res+"</select>";
     return res;
    }

    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();



    try{
        Class.forName("org.postgresql.Driver").newInstance();
        MiConexion = DriverManager.getConnection(Url,Usuario,Contraseña);

        if (MiConexion != null) {

       out.println("<h1>HAY CONEXION" + request.getContextPath () + "</h1>");
                 

            } else {
out.println("<h1>NOOOOO HAY CONEXION" + request.getContextPath () + "</h1>");
            }

}catch(Exception Ex ){

}





        try {
            
            out.println("<html>");
            out.println("<head>");
            out.println("<title>Servlet Coneccion</title>");  
            out.println("</head>");
            out.println("<body>");
            out.println("<h1>Estoy en El ServLet!!!!!!!!!!!!!!! " + request.getContextPath () + "</h1>");
            out.println("</body>");
            out.println("</html>");
            
        } finally { 
            out.close();
        }
    } 

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** 
     * Handles the HTTP <code>GET</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    } 

    /** 
     * Handles the HTTP <code>POST</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }

    /** 
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}
